select charvalincde, charvaldsc from r_charval inner join r_char on r_charval.charincde = r_char.charincde and charexcde = 'OBJ001' left outer join P_News on P_News.RcdIncde = r_charval.charvalincde group by charvaldsc , P_News.NewsIncde, charvalincde having P_News.NewsIncde is null¤select charvalincde, charvaldsc from r_charval inner join r_char on r_charval.charincde = r_char.charincde and charexcde = 'OBJ001' left outer join P_News on P_News.RcdIncde = r_charval.charvalincde group by charvaldsc , P_News.NewsIncde, charvalincde having P_News.NewsIncde is null¤